﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace JYH.DataAccess
{

    /// <summary>
    /// MSSQL数据表字段类
    /// </summary>
    public class TableColumnInfo
    {


        
        private string _TableID;
        /// <summary>
        /// 表ID
        /// </summary>
        public string TableID
        {
            get
            {
                return _TableID;
            }
            set
            {
                _TableID = value;
            }
        }
        
        private string _TableName;
        /// <summary>
        /// 表名
        /// </summary>
        public string TableName
        {
            get
            {
                return _TableName;
            }
            set
            {
                _TableName = value;
            }
        }


        private string _TableKey;
        /// <summary>
        /// 字段对应表名称
        /// </summary>
        public string TableKey
        {
            get
            {
                return _TableKey;
            }
            set
            {
                _TableKey = value;
            }
        }
        private string _ColumnIndex;
        /// <summary>
        /// 字段排序
        /// </summary>
        public string ColumnIndex
        {
            get
            {
                return _ColumnIndex;
            }
            set
            {
                _ColumnIndex = value;
            }
        }



        private string _ColumnName;
        /// <summary>
        /// 字段名称
        /// </summary>
        public string ColumnName
        {
            get
            {
                return _ColumnName;
            }
            set
            {
                _ColumnName = value;
            }
        }
        private string _ColIsIdentity;
        /// <summary>
        /// 是否索引字段
        /// </summary>
        public string ColIsIdentity
        {
            get
            {
                return _ColIsIdentity;
            }
            set
            {
                _ColIsIdentity = value;
            }
        }
        private string _MainKey;
        /// <summary>
        /// 是否主关键字段
        /// </summary>
        public string MainKey
        {
            get
            {
                return _MainKey;
            }
            set
            {
                _MainKey = value;
            }
        }
        private string _ColType;
        /// <summary>
        /// 字段类型
        /// </summary>
        public string ColType
        {
            get
            {
                return _ColType;
            }
            set
            {
                _ColType = value;
            }
        }
        private string _ColLength;
        /// <summary>
        /// 字段长度
        /// </summary>
        public string ColLength
        {
            get
            {
                return _ColLength;
            }
            set
            {
                _ColLength = value;
            }
        }
        private string _DecimalQty;
        /// <summary>
        /// 小数位长度
        /// </summary>
        public string DecimalQty
        {
            get
            {
                return _DecimalQty;
            }
            set
            {
                _DecimalQty = value;
            }
        }
        private string _ColIsNull;
        /// <summary>
        /// 是否允许为空
        /// </summary>
        public string ColIsNull
        {
            get
            {
                return _ColIsNull;
            }
            set
            {
                _ColIsNull = value;
            }
        }
        private string _DefaultValue;
        /// <summary>
        /// 字段默认值
        /// </summary>
        public string DefaultValue
        {
            get
            {
                return _DefaultValue;
            }
            set
            {
                _DefaultValue = value;
            }
        }
        private string _ColDesc;
        /// <summary>
        /// 字段中文说明
        /// </summary>
        public string ColDesc
        {
            get
            {
                return _ColDesc;
            }
            set
            {
                _ColDesc = value;
            }
        }

    }
}
